 create table `cugu`.`rk_area`(
        `id` INT not null auto_increment,
       `abbreviation` VARCHAR(255),
       `code` VARCHAR(255),
       `full_name` VARCHAR(255),
       `grade` INT,
       `parent_code` VARCHAR(255),
       `remark` VARCHAR(255),
       `status` INT,
        primary key (`id`)
    )charset=gbk;
 
  create table `cugu`.`rk_dic_menu`(
        `menu_id` INT not null auto_increment,
       `create_time` VARCHAR(255),
       `create_user` VARCHAR(255),
       `menu_name` VARCHAR(255),
       `menu_order` INT,
       `menu_url` VARCHAR(255),
       `modify_date` VARCHAR(255),
       `modify_user` VARCHAR(255),
       `parent_id` INT,
       `status` INT,
        primary key (`menu_id`)
    )charset=gbk;
    
    create table `cugu`.`rk_meal_box`(
        `id` INT not null auto_increment,
       `create_time` VARCHAR(255),
       `create_user` VARCHAR(255),
       `images` VARCHAR(255),
       `low_consume` DOUBLE,
       `name` VARCHAR(255),
       `people_number` INT,
       `remark` VARCHAR(255),
       `restaurantId` INT,
       `status` INT,
       `type` INT,
       `update_time` VARCHAR(255),
       `update_user` VARCHAR(255),
        primary key (`id`)
    )charset=gbk; 
    
     create table `cugu`.`rk_meal_menu_type`(
        `id` INT not null auto_increment,
       `menu_type_name` VARCHAR(255),
       `restaurant_id` INT,
       `status` INT,
        primary key (`id`)
    )charset=gbk;
    
    create table `cugu`.`rk_meal_menu`(
        `id` INT not null auto_increment,
       `favorable_id` INT,
       `images` VARCHAR(255),
       `introduce` VARCHAR(255),
       `is_sell` BIT,
       `meal_menu_id` INT,
       `menu_name` VARCHAR(255),
       `menu_type_id` INT,
       `order_by` INT,
       `price` DOUBLE,
       `is_recommend` BIT,
       `restaurant_id` INT,
       `special` DOUBLE,
       `status` INT,
       `taste` INT,
        primary key (`id`)
    )charset=gbk;
    
    create table `cugu`.`rk_meal_style`(
        `id` INT not null auto_increment,
       `name` VARCHAR(255),
       `status` INT,
        primary key (`id`)
    )charset=gbk; 
    
      create table `cugu`.`rk_privilege`(
        `privilege_id` INT not null auto_increment,
       `privilege_key` VARCHAR(255),
       `privilege_name` VARCHAR(255),
       `remark` VARCHAR(255),
       `status` INT,
        primary key (`privilege_id`)
    )charset=gbk;
    
     create table `cugu`.`rk_restaurant`(
        `id` INT not null auto_increment,
       `address` VARCHAR(255),
       `begin_time` VARCHAR(255),
       `city` VARCHAR(255),
       `district` VARCHAR(255),
       `end_time` VARCHAR(255),
       `images_1` VARCHAR(255),
       `images_2` VARCHAR(255),
       `images_3` VARCHAR(255),
       `images_4` VARCHAR(255),
       `is_schedule` BIT,
       `linkman` VARCHAR(255),
       `meal_style` VARCHAR(255),
       `moilbe` VARCHAR(255),
       `name` VARCHAR(255),
       `other` VARCHAR(255),
       `province` VARCHAR(255),
       `status` INT,
       `street` VARCHAR(255),
       `user_id` INT,
        primary key (`id`)
    )charset=gbk; 
    
       create table `cugu`.`rk_role_menu`(
        `id` INT not null auto_increment,
       `menu_id` INT,
       `role_id` INT,
        primary key (`id`)
    )charset=gbk;
    
     create table `cugu`.`rk_role_privilege`(
        `id` INT not null auto_increment,
       `privilege_id` INT,
       `role_id` INT,
        primary key (`id`)
    )charset=gbk;
    
    
    create table `cugu`.`rk_role`(
        `role_id` INT not null auto_increment,
       `create_time` VARCHAR(255),
       `create_user` VARCHAR(255),
       `remark` VARCHAR(255),
       `role_name` VARCHAR(255),
       `status` INT,
        primary key (`role_id`)
    )charset=gbk;
    
     create table `cugu`.`rk_user_role`(
        `id` INT not null auto_increment,
       `role_id` INT,
       `user_id` INT,
        primary key (`id`)
    )charset=gbk;
    
      create table `cugu`.`rk_user`(
        `user_id` INT not null auto_increment,
       `create_time` VARCHAR(255),
       `ip` VARCHAR(255),
       `login_status` INT,
       `login_time` VARCHAR(255),
       `login_version` VARCHAR(255),
       `real_name` VARCHAR(255),
       `status` INT,
       `user_address` VARCHAR(255),
       `user_email` VARCHAR(255),
       `user_id_no` VARCHAR(255),
       `user_mobile` VARCHAR(255),
       `user_name` VARCHAR(255),
       `user_phone` VARCHAR(255),
       `user_pwd` VARCHAR(255),
       `user_relation` VARCHAR(255),
       `user_sex` INT,
       `user_type` INT,
       `user_zip_code` VARCHAR(255),
        primary key (`user_id`)
    )charset=gbk;
    select * from rk_meal_preferential
       declare @t varchar(20);
       set @t = 'aaa'
       update rk_meal_preferential set name=CONCAT('家家乐',id,'')
       update rk_meal_menu set images='/images/aaa.jpg'
delete from rk_meal_preferential
insert  into `rk_meal_preferential`(`id`,`begin_date`,`copies`,`cost_price`,`discount`,`end_date`,`explanation`,`images`,`meal_menu_id`,`meal_package`,`name`,`package_remark`,`preferential_price`,`preferential_type`,`release_status`,`restaurant_id`,`status`) values (1,'2013-12-18 21:24:24',2333,12,11,'2014-01-28 21:24:27','撒的发','','',NULL,'阿斯蒂芬','',21,0,'\0',0,0),(2,'2013-12-09 21:29:53',11,110,0.8,'2013-12-31 21:29:55','说明','','',NULL,'打折优惠','',10,0,'\0',0,0),(3,'2013-12-10 10:03:26',1222,12,0.8,'2013-12-31 10:03:29','折扣','','',NULL,'asdfa','',9,0,'\0',0,0),(4,'2013-12-10 11:34:32',100,100,0.5,'2013-12-31 11:34:41','test1008 餐厅优惠','','',NULL,'test1008 优惠','',50,0,'\0',0,0),(5,'2013-12-10 11:38:38',11,20,0.5,'2013-12-31 11:38:41','test1008折扣','','',NULL,'test1008折扣','',10,0,'\0',0,2),(6,'2013-12-10 11:50:07',133,18,0.4,'2013-12-31 11:50:09','test1008五 说明','','',NULL,'test1008五','',8,0,'',1,2),(7,'',12,0,0.5,'','','','',NULL,'打折优惠','',0,0,'\0',1,0),(8,'',100,29,0.4,'','','','',NULL,'折上折','',13,0,'\0',1,0),(9,'2013-12-17 17:48:56',12,17,1.4,'2013-12-24 17:49:00','sad','','',NULL,'打折优惠','',24,0,'\0',1,0),(10,'2013-12-11 17:49:21',34,123,0.2,'2013-12-26 17:49:26','dfasd','','',NULL,'湘西间','',23,0,'\0',1,0),(11,'2013-12-11 17:49:21',24,23,0.4,'2013-12-26 17:49:26','eteaaa',NULL,NULL,NULL,'湘西间',NULL,24,0,'',1,0),(12,'2013-12-11 17:49:21',24,23,0.4,'2013-12-26 17:49:26','eteaaa',NULL,NULL,NULL,'湘西间',NULL,24,0,'',1,0),(13,'2013-12-11 17:49:21',24,23,0.4,'2013-12-26 17:49:26','eteaaa',NULL,NULL,NULL,'湘西间',NULL,24,0,'',1,0),(14,'2013-12-11 17:49:21',24,23,0.4,'2013-12-26 17:49:26','eteaaa',NULL,NULL,NULL,'湘西间',NULL,24,0,'',1,0),(15,'2013-12-11 17:49:21',24,23,0.4,'2013-12-26 17:49:26','eteaaa',NULL,NULL,NULL,'湘西间',NULL,24,0,'',1,0),(16,'2013-12-11 17:49:21',24,23,0.4,'2013-12-26 17:49:26','eteaaa',NULL,NULL,NULL,'湘西间',NULL,24,0,'',1,0),(17,'2013-12-11 17:49:21',24,23,0.4,'2013-12-26 17:49:26','eteaaa',NULL,NULL,NULL,'湘西间',NULL,24,0,'',1,0),(18,'2013-12-11 17:49:21',24,23,0.4,'2013-12-26 17:49:26','eteaaa',NULL,NULL,NULL,'湘西间',NULL,24,0,'',1,0),(19,'2013-12-11 17:49:21',24,23,0.4,'2013-12-26 17:49:26','eteaaa',NULL,NULL,NULL,'湘西间',NULL,24,0,'',1,0),(20,'2013-12-11 17:49:21',24,23,0.4,'2013-12-26 17:49:26','eteaaa',NULL,NULL,NULL,'湘西间',NULL,24,0,'',1,0),(21,'2013-12-11 17:49:21',24,23,0.4,'2013-12-26 17:49:26','eteaaa',NULL,NULL,NULL,'湘西间',NULL,24,0,'',1,0),(22,'2013-12-11 17:49:21',24,23,0.4,'2013-12-26 17:49:26','eteaaa',NULL,NULL,NULL,'湘西间',NULL,24,0,'',1,0),(23,'2013-12-11 17:49:21',24,23,0.4,'2013-12-26 17:49:26','eteaaa',NULL,NULL,NULL,'湘西间',NULL,24,0,'',1,0),(24,'2013-12-11 17:49:21',24,23,0.4,'2013-12-26 17:49:26','eteaaa',NULL,NULL,NULL,'湘西间',NULL,24,0,'',1,0),(25,'2013-12-11 17:49:21',24,23,0.4,'2013-12-26 17:49:26','eteaaa',NULL,NULL,NULL,'湘西间',NULL,24,0,'',1,0),(26,'2013-12-11 17:49:21',24,23,0.4,'2013-12-26 17:49:26','eteaaa',NULL,NULL,NULL,'湘西间',NULL,24,0,'',1,0),(27,'2013-12-11 17:49:21',24,23,0.4,'2013-12-26 17:49:26','eteaaa',NULL,NULL,NULL,'湘西间',NULL,24,0,'',1,0),(28,'2013-12-11 17:49:21',24,23,0.4,'2013-12-26 17:49:26','eteaaa',NULL,NULL,NULL,'湘西间',NULL,24,0,'',1,0),(29,'2013-12-11 17:49:21',24,23,0.4,'2013-12-26 17:49:26','eteaaa',NULL,NULL,NULL,'湘西间',NULL,24,0,'',1,0),(30,'2013-12-11 17:49:21',24,23,0.4,'2013-12-26 17:49:26','eteaaa',NULL,NULL,NULL,'湘西间',NULL,24,0,'',1,0),(31,'2013-12-11 17:49:21',24,23,0.4,'2013-12-26 17:49:26','eteaaa',NULL,NULL,NULL,'湘西间',NULL,24,0,'',1,0),(32,'2013-12-11 17:49:21',24,23,0.4,'2013-12-26 17:49:26','eteaaa',NULL,NULL,NULL,'湘西间',NULL,24,0,'',1,0),(33,'2013-12-11 17:49:21',24,23,0.4,'2013-12-26 17:49:26','eteaaa',NULL,NULL,NULL,'湘西间',NULL,24,0,'',1,0),(34,'2013-12-11 17:49:21',24,23,0.4,'2013-12-26 17:49:26','eteaaa',NULL,NULL,NULL,'湘西间',NULL,24,0,'',1,0),(35,'2013-12-11 17:49:21',24,23,0.4,'2013-12-26 17:49:26','eteaaa',NULL,NULL,NULL,'湘西间',NULL,24,0,'',1,0),(36,'2013-12-11 17:49:21',24,23,0.4,'2013-12-26 17:49:26','eteaaa',NULL,NULL,NULL,'湘西间',NULL,24,0,'',1,0),(37,'2013-12-11 17:49:21',24,23,0.4,'2013-12-26 17:49:26','eteaaa',NULL,NULL,NULL,'湘西间',NULL,24,0,'',1,0),(38,'2013-12-11 17:49:21',24,23,0.4,'2013-12-26 17:49:26','eteaaa',NULL,NULL,NULL,'湘西间',NULL,24,0,'',1,0),(39,'2013-12-11 17:49:21',24,23,0.4,'2013-12-26 17:49:26','eteaaa',NULL,NULL,NULL,'湘西间',NULL,24,0,'',1,0),(40,'2013-12-11 17:49:21',24,23,0.4,'2013-12-26 17:49:26','eteaaa',NULL,NULL,NULL,'湘西间',NULL,24,0,'',1,0),(41,'2013-12-11 17:49:21',24,23,0.4,'2013-12-26 17:49:26','eteaaa',NULL,NULL,NULL,'湘西间',NULL,24,0,'',1,0),(42,'2013-12-11 17:49:21',24,23,0.4,'2013-12-26 17:49:26','eteaaa',NULL,NULL,NULL,'湘西间',NULL,24,0,'',1,0),(43,'2013-12-11 17:49:21',24,23,0.4,'2013-12-26 17:49:26','eteaaa',NULL,NULL,NULL,'湘西间',NULL,24,0,'',1,0),(44,'2013-12-11 17:49:21',24,23,0.4,'2013-12-26 17:49:26','eteaaa',NULL,NULL,NULL,'湘西间',NULL,24,0,'',1,0),(45,'2013-12-11 17:49:21',24,23,0.4,'2013-12-26 17:49:26','eteaaa',NULL,NULL,NULL,'湘西间',NULL,24,0,'',1,0),(46,'2013-12-11 17:49:21',24,23,0.4,'2013-12-26 17:49:26','eteaaa',NULL,NULL,NULL,'湘西间',NULL,24,0,'',1,0),(47,'2013-12-11 17:49:21',24,23,0.4,'2013-12-26 17:49:26','eteaaa',NULL,NULL,NULL,'湘西间',NULL,24,0,'',1,0),(48,'2013-12-11 17:49:21',24,23,0.4,'2013-12-26 17:49:26','eteaaa',NULL,NULL,NULL,'湘西间',NULL,24,0,'',1,0),(49,'2013-12-11 17:49:21',24,23,0.4,'2013-12-26 17:49:26','eteaaa',NULL,NULL,NULL,'湘西间',NULL,24,0,'',1,0),(50,'2013-12-11 17:49:21',24,23,0.4,'2013-12-26 17:49:26','eteaaa',NULL,NULL,NULL,'湘西间',NULL,24,0,'',1,0),(51,'2013-12-11 17:49:21',24,23,0.4,'2013-12-26 17:49:26','eteaaa',NULL,NULL,NULL,'湘西间',NULL,24,0,'',1,0),(52,'2013-12-11 17:49:21',24,23,0.4,'2013-12-26 17:49:26','eteaaa',NULL,NULL,NULL,'湘西间',NULL,24,0,'',1,0),(53,'2013-12-11 17:49:21',24,23,0.4,'2013-12-26 17:49:26','eteaaa',NULL,NULL,NULL,'湘西间',NULL,24,0,'',1,0),(54,'2013-12-11 17:49:21',24,23,0.4,'2013-12-26 17:49:26','eteaaa',NULL,NULL,NULL,'湘西间',NULL,24,0,'',1,0),(55,'2013-12-11 17:49:21',24,23,0.4,'2013-12-26 17:49:26','eteaaa',NULL,NULL,NULL,'湘西间',NULL,24,0,'',1,0),(56,'2013-12-11 17:49:21',24,23,0.4,'2013-12-26 17:49:26','eteaaa',NULL,NULL,NULL,'湘西间',NULL,24,0,'',1,0),(57,'2013-12-11 17:49:21',24,23,0.4,'2013-12-26 17:49:26','eteaaa',NULL,NULL,NULL,'湘西间',NULL,24,0,'',1,0),(58,'2013-12-11 17:49:21',24,23,0.4,'2013-12-26 17:49:26','eteaaa',NULL,NULL,NULL,'湘西间',NULL,24,0,'',1,0),(59,'2013-12-11 17:49:21',24,23,0.4,'2013-12-26 17:49:26','eteaaa',NULL,NULL,NULL,'湘西间',NULL,24,0,'',1,0),(60,'2013-12-11 17:49:21',24,23,0.4,'2013-12-26 17:49:26','eteaaa',NULL,NULL,NULL,'湘西间',NULL,24,0,'',1,0);insert  into `rk_meal_preferential`(`id`,`begin_date`,`copies`,`cost_price`,`discount`,`end_date`,`explanation`,`images`,`meal_menu_id`,`meal_package`,`name`,`package_remark`,`preferential_price`,`preferential_type`,`release_status`,`restaurant_id`,`status`) values (1,'2013-12-18 21:24:24',2333,12,11,'2014-01-28 21:24:27','撒的发','','',NULL,'阿斯蒂芬','',21,0,'\0',0,0),(2,'2013-12-09 21:29:53',11,110,0.8,'2013-12-31 21:29:55','说明','','',NULL,'打折优惠','',10,0,'\0',0,0),(3,'2013-12-10 10:03:26',1222,12,0.8,'2013-12-31 10:03:29','折扣','','',NULL,'asdfa','',9,0,'\0',0,0),(4,'2013-12-10 11:34:32',100,100,0.5,'2013-12-31 11:34:41','test1008 餐厅优惠','','',NULL,'test1008 优惠','',50,0,'\0',0,0),(5,'2013-12-10 11:38:38',11,20,0.5,'2013-12-31 11:38:41','test1008折扣','','',NULL,'test1008折扣','',10,0,'\0',0,2),(6,'2013-12-10 11:50:07',133,18,0.4,'2013-12-31 11:50:09','test1008五 说明','','',NULL,'test1008五','',8,0,'',1,2),(7,'',12,0,0.5,'','','','',NULL,'打折优惠','',0,0,'\0',1,0),(8,'',100,29,0.4,'','','','',NULL,'折上折','',13,0,'\0',1,0),(9,'2013-12-17 17:48:56',12,17,1.4,'2013-12-24 17:49:00','sad','','',NULL,'打折优惠','',24,0,'\0',1,0),(10,'2013-12-11 17:49:21',34,123,0.2,'2013-12-26 17:49:26','dfasd','','',NULL,'湘西间','',23,0,'\0',1,0),(11,'2013-12-11 17:49:21',24,23,0.4,'2013-12-26 17:49:26','eteaaa',NULL,NULL,NULL,'湘西间',NULL,24,0,'',1,0),(12,'2013-12-11 17:49:21',24,23,0.4,'2013-12-26 17:49:26','eteaaa',NULL,NULL,NULL,'湘西间',NULL,24,0,'',1,0),(13,'2013-12-11 17:49:21',24,23,0.4,'2013-12-26 17:49:26','eteaaa',NULL,NULL,NULL,'湘西间',NULL,24,0,'',1,0),(14,'2013-12-11 17:49:21',24,23,0.4,'2013-12-26 17:49:26','eteaaa',NULL,NULL,NULL,'湘西间',NULL,24,0,'',1,0),(15,'2013-12-11 17:49:21',24,23,0.4,'2013-12-26 17:49:26','eteaaa',NULL,NULL,NULL,'湘西间',NULL,24,0,'',1,0),(16,'2013-12-11 17:49:21',24,23,0.4,'2013-12-26 17:49:26','eteaaa',NULL,NULL,NULL,'湘西间',NULL,24,0,'',1,0),(17,'2013-12-11 17:49:21',24,23,0.4,'2013-12-26 17:49:26','eteaaa',NULL,NULL,NULL,'湘西间',NULL,24,0,'',1,0),(18,'2013-12-11 17:49:21',24,23,0.4,'2013-12-26 17:49:26','eteaaa',NULL,NULL,NULL,'湘西间',NULL,24,0,'',1,0),(19,'2013-12-11 17:49:21',24,23,0.4,'2013-12-26 17:49:26','eteaaa',NULL,NULL,NULL,'湘西间',NULL,24,0,'',1,0),(20,'2013-12-11 17:49:21',24,23,0.4,'2013-12-26 17:49:26','eteaaa',NULL,NULL,NULL,'湘西间',NULL,24,0,'',1,0),(21,'2013-12-11 17:49:21',24,23,0.4,'2013-12-26 17:49:26','eteaaa',NULL,NULL,NULL,'湘西间',NULL,24,0,'',1,0),(22,'2013-12-11 17:49:21',24,23,0.4,'2013-12-26 17:49:26','eteaaa',NULL,NULL,NULL,'湘西间',NULL,24,0,'',1,0),(23,'2013-12-11 17:49:21',24,23,0.4,'2013-12-26 17:49:26','eteaaa',NULL,NULL,NULL,'湘西间',NULL,24,0,'',1,0),(24,'2013-12-11 17:49:21',24,23,0.4,'2013-12-26 17:49:26','eteaaa',NULL,NULL,NULL,'湘西间',NULL,24,0,'',1,0),(25,'2013-12-11 17:49:21',24,23,0.4,'2013-12-26 17:49:26','eteaaa',NULL,NULL,NULL,'湘西间',NULL,24,0,'',1,0),(26,'2013-12-11 17:49:21',24,23,0.4,'2013-12-26 17:49:26','eteaaa',NULL,NULL,NULL,'湘西间',NULL,24,0,'',1,0),(27,'2013-12-11 17:49:21',24,23,0.4,'2013-12-26 17:49:26','eteaaa',NULL,NULL,NULL,'湘西间',NULL,24,0,'',1,0),(28,'2013-12-11 17:49:21',24,23,0.4,'2013-12-26 17:49:26','eteaaa',NULL,NULL,NULL,'湘西间',NULL,24,0,'',1,0),(29,'2013-12-11 17:49:21',24,23,0.4,'2013-12-26 17:49:26','eteaaa',NULL,NULL,NULL,'湘西间',NULL,24,0,'',1,0),(30,'2013-12-11 17:49:21',24,23,0.4,'2013-12-26 17:49:26','eteaaa',NULL,NULL,NULL,'湘西间',NULL,24,0,'',1,0),(31,'2013-12-11 17:49:21',24,23,0.4,'2013-12-26 17:49:26','eteaaa',NULL,NULL,NULL,'湘西间',NULL,24,0,'',1,0),(32,'2013-12-11 17:49:21',24,23,0.4,'2013-12-26 17:49:26','eteaaa',NULL,NULL,NULL,'湘西间',NULL,24,0,'',1,0),(33,'2013-12-11 17:49:21',24,23,0.4,'2013-12-26 17:49:26','eteaaa',NULL,NULL,NULL,'湘西间',NULL,24,0,'',1,0),(34,'2013-12-11 17:49:21',24,23,0.4,'2013-12-26 17:49:26','eteaaa',NULL,NULL,NULL,'湘西间',NULL,24,0,'',1,0),(35,'2013-12-11 17:49:21',24,23,0.4,'2013-12-26 17:49:26','eteaaa',NULL,NULL,NULL,'湘西间',NULL,24,0,'',1,0),(36,'2013-12-11 17:49:21',24,23,0.4,'2013-12-26 17:49:26','eteaaa',NULL,NULL,NULL,'湘西间',NULL,24,0,'',1,0),(37,'2013-12-11 17:49:21',24,23,0.4,'2013-12-26 17:49:26','eteaaa',NULL,NULL,NULL,'湘西间',NULL,24,0,'',1,0),(38,'2013-12-11 17:49:21',24,23,0.4,'2013-12-26 17:49:26','eteaaa',NULL,NULL,NULL,'湘西间',NULL,24,0,'',1,0),(39,'2013-12-11 17:49:21',24,23,0.4,'2013-12-26 17:49:26','eteaaa',NULL,NULL,NULL,'湘西间',NULL,24,0,'',1,0),(40,'2013-12-11 17:49:21',24,23,0.4,'2013-12-26 17:49:26','eteaaa',NULL,NULL,NULL,'湘西间',NULL,24,0,'',1,0),(41,'2013-12-11 17:49:21',24,23,0.4,'2013-12-26 17:49:26','eteaaa',NULL,NULL,NULL,'湘西间',NULL,24,0,'',1,0),(42,'2013-12-11 17:49:21',24,23,0.4,'2013-12-26 17:49:26','eteaaa',NULL,NULL,NULL,'湘西间',NULL,24,0,'',1,0),(43,'2013-12-11 17:49:21',24,23,0.4,'2013-12-26 17:49:26','eteaaa',NULL,NULL,NULL,'湘西间',NULL,24,0,'',1,0),(44,'2013-12-11 17:49:21',24,23,0.4,'2013-12-26 17:49:26','eteaaa',NULL,NULL,NULL,'湘西间',NULL,24,0,'',1,0),(45,'2013-12-11 17:49:21',24,23,0.4,'2013-12-26 17:49:26','eteaaa',NULL,NULL,NULL,'湘西间',NULL,24,0,'',1,0),(46,'2013-12-11 17:49:21',24,23,0.4,'2013-12-26 17:49:26','eteaaa',NULL,NULL,NULL,'湘西间',NULL,24,0,'',1,0),(47,'2013-12-11 17:49:21',24,23,0.4,'2013-12-26 17:49:26','eteaaa',NULL,NULL,NULL,'湘西间',NULL,24,0,'',1,0),(48,'2013-12-11 17:49:21',24,23,0.4,'2013-12-26 17:49:26','eteaaa',NULL,NULL,NULL,'湘西间',NULL,24,0,'',1,0),(49,'2013-12-11 17:49:21',24,23,0.4,'2013-12-26 17:49:26','eteaaa',NULL,NULL,NULL,'湘西间',NULL,24,0,'',1,0),(50,'2013-12-11 17:49:21',24,23,0.4,'2013-12-26 17:49:26','eteaaa',NULL,NULL,NULL,'湘西间',NULL,24,0,'',1,0),(51,'2013-12-11 17:49:21',24,23,0.4,'2013-12-26 17:49:26','eteaaa',NULL,NULL,NULL,'湘西间',NULL,24,0,'',1,0),(52,'2013-12-11 17:49:21',24,23,0.4,'2013-12-26 17:49:26','eteaaa',NULL,NULL,NULL,'湘西间',NULL,24,0,'',1,0),(53,'2013-12-11 17:49:21',24,23,0.4,'2013-12-26 17:49:26','eteaaa',NULL,NULL,NULL,'湘西间',NULL,24,0,'',1,0),(54,'2013-12-11 17:49:21',24,23,0.4,'2013-12-26 17:49:26','eteaaa',NULL,NULL,NULL,'湘西间',NULL,24,0,'',1,0),(55,'2013-12-11 17:49:21',24,23,0.4,'2013-12-26 17:49:26','eteaaa',NULL,NULL,NULL,'湘西间',NULL,24,0,'',1,0),(56,'2013-12-11 17:49:21',24,23,0.4,'2013-12-26 17:49:26','eteaaa',NULL,NULL,NULL,'湘西间',NULL,24,0,'',1,0),(57,'2013-12-11 17:49:21',24,23,0.4,'2013-12-26 17:49:26','eteaaa',NULL,NULL,NULL,'湘西间',NULL,24,0,'',1,0),(58,'2013-12-11 17:49:21',24,23,0.4,'2013-12-26 17:49:26','eteaaa',NULL,NULL,NULL,'湘西间',NULL,24,0,'',1,0),(59,'2013-12-11 17:49:21',24,23,0.4,'2013-12-26 17:49:26','eteaaa',NULL,NULL,NULL,'湘西间',NULL,24,0,'',1,0),(60,'2013-12-11 17:49:21',24,23,0.4,'2013-12-26 17:49:26','eteaaa',NULL,NULL,NULL,'湘西间',NULL,24,0,'',1,0);
 update rk_meal_menu set menu_name=CONCAT('麻婆豆腐',id,'')
select * from rk_meal_menu

insert into rk_meal_menu(favorable_id,images,introduce,is_sell,meal_menu_id,menu_name,menu_type_id,order_by,price,is_recommend,restaurant_id,status) select favorable_id,images,introduce,is_sell,meal_menu_id,menu_name,menu_type_id,order_by,price,is_recommend,restaurant_id,status from rk_meal_menu

select rmm.id,menu_name,meal_menu_id,is_sell,introduce,images,order_by,price,taste,rmm.is_recommend,(select name from rk_meal_style where id=menu_type_id) style_name from rk_restaurant as res,rk_meal_menu rmm where res.id=rmm.restaurant_id

select rmm.id,menu_name,meal_menu_id,is_sell,introduce,images,order_by,price,taste,rmm.is_recommend,rms.name from rk_restaurant as res,rk_meal_menu rmm,rk_meal_style rms where rms.id=rmm.menu_type_id and res.id=rmm.restaurant_id